Mega Code Archive - Oracle PLSQL

Constraints
1) A check constraint can also be created or added as a table constraint
2) A unique constraint can be extended over multiple columns
3) Add another check constraint
4) Add constraint for a column
5) Add constraint for date type column
6) Add constraint foreign key references
7) Add constraint to a column and give it a name
8) Add constraint to ensure that value from one column is bigger than that from another
9) Add Foreign key Demo
10) Add Foreign Primary Key
11) Add not null constraint to different columns
12) Add Primary Key
13) Add primary key and try to insert default value to it
14) Add primary key as the last statement
15) Add two conditions for one column
16) Add unique constraints
17) Add unique containt to a varchar2 type column
18) Adding a check constraint that allows null values
19) Adding constraint that checks values and prohobits nulls
20) Adding constraints to a table
21) Alter a table to insert primary key and index
22) Alter table dept add emp_count number, constraint must_be_between_3_8, check(emp_count between 3 and 8 OR emp_count = 0), defe
23) Alter table dept modify emp_count NOT NULL
24) Alter table to add constraint with name
25) Alter table to add primary key
26) Alter table to add primary key and alter another table to add foreign key
27) Alter table to drop constraint with name
28) Alter table to primary key and check it in user_ind_columns and user_cons_columns
29) Alter to add primary key
30) Change a column to not null with null data in it
31) Check date type column for nullable and value range
32) Check nullable and value range for one single column data
33) Constraint check with in function
34) Constraint check with upper function
35) Constraint types
36) Constriant
37) Contraint type
38) Could only contain three values
39) Create a foreign key set null on delete with more than one field
40) Create a foreign key set null on delete with more than one field, and use desc to check
41) Create a foreign key with a cascade delete with more than one field
42) Create a foreign key with more than one field
43) Create a primary key with more than one field
44) Create a SQL collection type that disallows null values
45) Create a table with unique deferrable initially immediate
46) Create table with foreign key
47) Declaring a Foreign Key
48) Deferrable initially immediate
49) Deferring Constraint Checking
50) DISTINCT keyword with primary key in select clause
51) Disable a Primary Key
52) Disable foreign key
53) Drop a primary key
54) Drop a UNIQUE constraint without specifying its name by referencing the column or columns
55) Drop cascade constraints Demo
56) Drop table with Foreign Key
57) Drop the foreign key
58) Drop Unique Constraint and Add Primary Key
59) DUP_VAL_ON_INDEX exception
60) Enable a primary key
61) Follow the contraint
62) Foreign key with cascade delete
63) Foreign Keys with set null on delete
64) If a column is not explicitely defined as not null, nulls can be inserted multiple times
65) Joined primary key
66) Many to many using a primary-key and foreign-key relationship
67) Must be upper case
68) Name the constraint
69) Naming contraints
70) NOT NULL Column Constraints
71) NOT NULL CONSTRAINT
72) One to many using a primary-key and foreign-key relationship
73) One-to-one using a primary-key and foreign-key relationship
74) ORA-00001
75) ORA-01400
76) ORA-12991
77) Primary Key
78) Primary keys can explicitely be named
79) Referential Integrity Constraints
80) Salary column value cannot be greater than 1000
81) Set primary key when declaring a column
82) Setting a Unique Constraint
83) Setting CHECK constraint for number type field
84) Setting primary key as declaring the column
85) Setting the Check constraint for int value field during declaration
86) State a check constraint that check relation between two columns
87) Syntax for adding check constraint to a column
88) Syntax to reference foreign key
89) SYS SYS_C004353 is the contraint name
90) Three foreign keys in a table
91) Unique value column
92) Use alter table to add foreign key with cascade delete
93) Use alter table to add foreign key with cascade delete for more than one column
94) Use decode() function in check constraints
95) Use three columns as primary key
96) Using a CREATE TABLE statement
97) Valiate foreign key example
98) Vialate the unique contraint
99) Violate a check constraint
100) Violate a foreign key
101) Violate constraints
102) Violate the primary key and foreign key relation